home *** CD-ROM | disk | FTP | other *** search
- FV (Future Value)
- Calculates the future value of an investment and a series of added payments, based on a given interest rate and a given number of periods.
-
- Format: FV (rate, nper, pmt{, pv}{, type})
-
- Arguments:
- ΓÇó rate: Interest rate per period.
- ΓÇó nper: Number of periods.
- ΓÇó pmt: Payment to be made per period.
- ΓÇó pv: Optional. Present value of investment.
- ΓÇó type: Optional. Type of payment scheme. (0 or 1; preset to 0, which means payments are due at the end of the period.)
-
- Example:
- FV (9%,12,-100,-3000) returns £10452.07 (using the Currency format).
- Shows the future value of an investment of £3,000, to which £100 annual payments are added for 12 years at a 9% rate of return.